RFM ANALYSIS¶

Out[3]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 01-12-2010 08:26 2.55 17850.0 United Kingdom
1 536365 71053 WHITE METAL LANTERN 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 01-12-2010 08:26 2.75 17850.0 United Kingdom
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
... ... ... ... ... ... ... ... ...
994 536520 22092 BLUE PAISLEY TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
995 536520 22469 HEART OF WICKER SMALL 1 01-12-2010 12:43 1.65 14729.0 United Kingdom
996 536520 22100 SKULLS SQUARE TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
997 536520 22096 PINK PAISLEY SQUARE TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
998 536520 22583 PACK OF 6 HANDBAG GIFT BOXES 1 01-12-2010 12:43 2.55 14729.0 United Kingdom

999 rows × 8 columns

Out[4]:
'01-12-2010 12:43'
Out[5]:
count mean std min 25% 50% 75% max
Quantity 999.0 12.795796 38.441434 -24.0 2.00 4.0 12.00 600.0
UnitPrice 999.0 3.038899 5.899624 0.0 1.25 2.1 3.75 165.0
CustomerID 998.0 16024.426854 1865.614470 12431.0 14688.00 16210.0 17908.00 18085.0
Out[6]:
InvoiceNo       object
StockCode       object
Description     object
Quantity         int64
InvoiceDate     object
UnitPrice      float64
CustomerID     float64
Country         object
dtype: object
Out[8]:
InvoiceNo              object
StockCode              object
Description            object
Quantity                int64
InvoiceDate    datetime64[ns]
UnitPrice             float64
CustomerID            float64
Country                object
dtype: object
2010-01-13 00:00:00
Out[11]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country TotalSum Frequency
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 2010-01-12 08:26:00 2.55 17850.0 United Kingdom 15.30 0 days 15:34:00
1 536365 71053 WHITE METAL LANTERN 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 0 days 15:34:00
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 2010-01-12 08:26:00 2.75 17850.0 United Kingdom 22.00 0 days 15:34:00
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 0 days 15:34:00
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 0 days 15:34:00
... ... ... ... ... ... ... ... ... ... ...
994 536520 22092 BLUE PAISLEY TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 0 days 11:17:00
995 536520 22469 HEART OF WICKER SMALL 1 2010-01-12 12:43:00 1.65 14729.0 United Kingdom 1.65 0 days 11:17:00
996 536520 22100 SKULLS SQUARE TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 0 days 11:17:00
997 536520 22096 PINK PAISLEY SQUARE TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 0 days 11:17:00
998 536520 22583 PACK OF 6 HANDBAG GIFT BOXES 1 2010-01-12 12:43:00 2.55 14729.0 United Kingdom 2.55 0 days 11:17:00

999 rows × 10 columns

Out[13]:
InvoiceDate InvoiceNo TotalSum
CustomerID
12431.0 13.950000 14 358.25
12583.0 15.250000 20 855.86
12791.0 12.550000 2 192.60
12838.0 12.050000 59 390.79
13047.0 15.416667 17 366.63
13255.0 12.033333 6 225.70
13408.0 13.350000 11 1024.68
13448.0 13.116667 18 443.96
13694.0 11.800000 6 842.12
13705.0 13.516667 10 318.14
13747.0 13.383333 1 79.60
13748.0 15.000000 1 204.00
13758.0 11.866667 17 362.45
13767.0 13.216667 14 507.88
14045.0 12.466667 1 326.40
14307.0 12.316667 48 783.11
14527.0 14.316667 1 -27.50
14688.0 14.383333 19 444.98
14729.0 11.283333 54 265.87
14849.0 11.616667 17 355.84
15100.0 14.850000 1 350.40
15291.0 14.466667 2 328.80
15311.0 14.183333 36 445.33
15513.0 12.633333 3 357.00
15862.0 12.650000 64 354.23
15983.0 11.750000 32 440.89
16029.0 14.033333 8 3702.12
16098.0 14.250000 12 430.60
16210.0 11.550000 14 2474.74
16218.0 12.516667 28 471.30
16250.0 14.016667 14 226.14
16552.0 11.400000 5 95.29
16583.0 11.950000 14 233.45
17181.0 11.366667 2 155.52
17377.0 11.416667 15 223.90
17420.0 14.066667 7 130.85
17511.0 13.683333 24 1825.74
17548.0 13.600000 7 -141.48
17809.0 14.316667 1 34.80
17850.0 12.433333 84 1499.34
17897.0 11.366667 36 140.39
17908.0 12.250000 58 243.28
17920.0 12.183333 81 514.41
17924.0 13.150000 2 279.00
17951.0 11.333333 5 295.50
17968.0 11.616667 85 277.35
18074.0 14.116667 13 489.60
18085.0 11.866667 9 303.90
Out[15]:
Recency Frequency Monetary
CustomerID
12431.0 13.950000 14 358.25
12583.0 15.250000 20 855.86
12791.0 12.550000 2 192.60
12838.0 12.050000 59 390.79
13047.0 15.416667 17 366.63
13255.0 12.033333 6 225.70
13408.0 13.350000 11 1024.68
13448.0 13.116667 18 443.96
13694.0 11.800000 6 842.12
13705.0 13.516667 10 318.14
13747.0 13.383333 1 79.60
13748.0 15.000000 1 204.00
13758.0 11.866667 17 362.45
13767.0 13.216667 14 507.88
14045.0 12.466667 1 326.40
14307.0 12.316667 48 783.11
14527.0 14.316667 1 -27.50
14688.0 14.383333 19 444.98
14729.0 11.283333 54 265.87
14849.0 11.616667 17 355.84
15100.0 14.850000 1 350.40
15291.0 14.466667 2 328.80
15311.0 14.183333 36 445.33
15513.0 12.633333 3 357.00
15862.0 12.650000 64 354.23
15983.0 11.750000 32 440.89
16029.0 14.033333 8 3702.12
16098.0 14.250000 12 430.60
16210.0 11.550000 14 2474.74
16218.0 12.516667 28 471.30
16250.0 14.016667 14 226.14
16552.0 11.400000 5 95.29
16583.0 11.950000 14 233.45
17181.0 11.366667 2 155.52
17377.0 11.416667 15 223.90
17420.0 14.066667 7 130.85
17511.0 13.683333 24 1825.74
17548.0 13.600000 7 -141.48
17809.0 14.316667 1 34.80
17850.0 12.433333 84 1499.34
17897.0 11.366667 36 140.39
17908.0 12.250000 58 243.28
17920.0 12.183333 81 514.41
17924.0 13.150000 2 279.00
17951.0 11.333333 5 295.50
17968.0 11.616667 85 277.35
18074.0 14.116667 13 489.60
18085.0 11.866667 9 303.90
Out[17]:
Recency Frequency Monetary R F M
CustomerID
12431.0 13.950000 14 358.25 2 2 3
12583.0 15.250000 20 855.86 1 3 4
12791.0 12.550000 2 192.60 3 1 1
12838.0 12.050000 59 390.79 3 4 3
13047.0 15.416667 17 366.63 1 3 3
Out[18]:
Recency Frequency Monetary R F M RFM_Segment_Concat
CustomerID
12431.0 13.950000 14 358.25 2 2 3 2.02.03.0
12583.0 15.250000 20 855.86 1 3 4 1.03.04.0
12791.0 12.550000 2 192.60 3 1 1 3.01.01.0
12838.0 12.050000 59 390.79 3 4 3 3.04.03.0
13047.0 15.416667 17 366.63 1 3 3 1.03.03.0
34
CustomerID
12431.0     7
12583.0     8
12791.0     5
12838.0    10
13047.0     7
Name: RFM_Score, dtype: int64
Out[20]:
Recency Frequency Monetary R F M RFM_Segment_Concat RFM_Score RFM_Level
CustomerID
12431.0 13.950000 14 358.25 2 2 3 2.02.03.0 7 Loyal/Commited
12583.0 15.250000 20 855.86 1 3 4 1.03.04.0 8 Champions
12791.0 12.550000 2 192.60 3 1 1 3.01.01.0 5 Promising
12838.0 12.050000 59 390.79 3 4 3 3.04.03.0 10 Can't Loose Them
13047.0 15.416667 17 366.63 1 3 3 1.03.03.0 7 Loyal/Commited
13255.0 12.033333 6 225.70 3 2 1 3.02.01.0 6 Potential
13408.0 13.350000 11 1024.68 2 2 4 2.02.04.0 8 Champions
13448.0 13.116667 18 443.96 2 3 3 2.03.03.0 8 Champions
13694.0 11.800000 6 842.12 4 2 4 4.02.04.0 10 Can't Loose Them
13705.0 13.516667 10 318.14 2 2 2 2.02.02.0 6 Potential
13747.0 13.383333 1 79.60 2 1 1 2.01.01.0 4 Requires Attention
13748.0 15.000000 1 204.00 1 1 1 1.01.01.0 3 Demands Activation
13758.0 11.866667 17 362.45 4 3 3 4.03.03.0 10 Can't Loose Them
13767.0 13.216667 14 507.88 2 2 4 2.02.04.0 8 Champions
14045.0 12.466667 1 326.40 3 1 2 3.01.02.0 6 Potential
                   Recency Frequency Monetary      
                      mean      mean     mean count
RFM_Level                                          
Can't Loose Them      12.1      44.2    702.6    16
Champions             13.3      16.4    938.5     8
Demands Activation    14.5       1.0     70.4     3
Loyal/Commited        13.4      12.1    363.6     7
Potential             12.7       7.1    254.0     7
Promising             13.1       3.7    110.0     3
Requires Attention    14.2       2.8    222.4     4